﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[UpdateProfileFamily]
	@ProfieID bigint,
	@RelationshipStatusID smallint,
	@RelationshipStatusIDPrivacy smallint,
	@RelatedProfileID bigint,
	@AniversaryDate datetime,
	@FamilyPrivacy smallint,
	@FriendsPrivacy smallint
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

   UPDATE ProfileInfo SET
   RelationshipStatusID=@RelationshipStatusID,
   RelationshipStatusPrivacy=@RelationshipStatusIDPrivacy,
   RelatedProfileID=@RelatedProfileID,
   AniversaryDate=@AniversaryDate,
   FamilyPrivacy=@FamilyPrivacy,
   FriendsPrivacy=@FriendsPrivacy,
   ModifiedDate=GETDATE()
   WHERE ProfileID=@ProfieID
END


